//package com.example.other;
//
//import com.alibaba.excel.EasyExcel;
//import com.alibaba.excel.ExcelReader;
//import com.alibaba.excel.ExcelWriter;
//import com.alibaba.excel.read.metadata.ReadSheet;
//import com.alibaba.excel.write.metadata.WriteSheet;
//import com.example.other.dto.ExcelDto;
//import com.example.other.dto.WftDto;
//import com.example.other.dto.WriteFileDto;
//import lombok.extern.slf4j.Slf4j;
//import org.junit.jupiter.api.Test;
//import org.springframework.boot.test.context.SpringBootTest;
//
//import java.util.List;
//
///**
// * @description：TODO
// * @author：yufan.wang
// * @create：2023/8/15 10:43
// */
//@SpringBootTest
//@Slf4j
//public class MargeExcel {
//    @Test
//    public void apply(){
//        String readFile = "C:\\Users\\yufan.wang\\Desktop\\乌鲁木齐银行技术标准(1).xlsx";
//
//        String writeFile = "C:\\Users\\yufan.wang\\Desktop\\不同.xlsx";
//
//
//        List<ReadSheet> readSheets = EasyExcel.read(readFile).build().excelExecutor().sheetList();
//
//        List<ExcelDto> whlist = EasyExcel.read(fileName).head(ExcelDto.class).sheet().doReadSync();
//
//
//        ExcelReader excelReader = EasyExcel.read(wftfileName).build();
//
//        ExcelWriter excelWriter = EasyExcel.write(writeFile, WriteFileDto.class).build();
//
//        if (!wftSheets.isEmpty()) {
//            wftSheets.forEach(sheet->{
//
//                ReadSheet finalSheet = sheet;
//
//                //IndexOrNameDataListener<WftDto> readListener = new IndexOrNameDataListener();
//                //excelReader.read(EasyExcel.readSheet(sheet.getSheetNo()).head(WftDto.class).registerReadListener(readListener).build());
//                //
//                List<WftDto> wftlist = EasyExcel.read(wftfileName).head(WftDto.class).sheet(finalSheet.getSheetNo()).doReadSync();
//
//
//                List<WriteFileDto> extracted = extracted111(whlist,wftlist);
//
//                WriteSheet writeSheet = EasyExcel.writerSheet( finalSheet.getSheetNo(),finalSheet.getSheetName()).head(WriteFileDto.class).build();
//                excelWriter.write(extracted, writeSheet);
//
//            });
//        }
//        excelReader.finish();
//        excelWriter.finish();
//
//
//
//    }
//}
